home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
BUSINESS
/
YCOLECT2.LZH
/
COLL-C41.EXE
/
COLLECT.ACS
/
COLLPGET.DOC
< prev
next >
Wrap
Text File
|
1990-08-14
|
5KB
|
114 lines
Description of fields displayed in option 1:
Notσá tha⌠ fielΣ field≤ displayeΣ verticall∙ iε thi≤ Hel≡ screeε arσá showε ì
horizonatall∙ iε selectioε ▒ oµ thi≤ menu.
Vertical Listing of fields used in the Payment Detail File:
Field Field Name Type Width Decimal
1 PROSPECT Character 40
2 CATEGORY Numeric 8
3 PERCENT_PD Numeric 4
4 GROSS_OWED Numeric 12 2
5 GROSS_PAID Numeric 12 2
6 NET_OWED Numeric 12 2
7 STREAM Numeric 8
8 ESCALATE_1 Numeric 4
9 ESCALATE_2 Numeric 4
10 DE_ESCALAT Numeric 4
11 DE_ESCAL Logical 1
12 LTRS_SENT Numeric 8
13 ACTIVATED Logical 1
14 STREAM_BGN Date 8
15 SEQUENCE Numeric 8
16 NEXT_LETTR Numeric 8
17 NEXT_LTR Date 8
18 NXLTR_DTNL Numeric 8
19 STREAM_FIN Logical 1
20 DATE_LASTL Date 8
21 CROSSOVER Numeric 4
22 CROSS_STRM Numeric 8
23 FIRST_ACT Date 8
24 MISC1 Numeric 8
25 MISC2 Numeric 8
26 MISC3 Numeric 8
27 MISC4 Date 8
28 MISC5 Logical 1
29 MISC6 Numeric 12 2
30 MISC7 Numeric 12 2
31 MISC8 Logical 1
32 MISC9 Numeric 4
33 MISC10 Numeric 4
34 PROSPMEMO Memo 10
** Total ** 264
Field by field definition of Payment Detail File:
Observσá tha⌠á field≤ witΦ asterisk≤ '*º identif∙ thosσá tha⌠á thσá prograφ ì
calculate≤ o≥ maintain≤ internall∙ anΣ automatically« Field≤ markeΣ witΦ ß ì
'#º arσ editablσ oε thσ Prospect\Debto≥ Ge⌠ screen¼ selectioε F5¼ optioε 3.
Field Field Name
1 PROSPECT <== Company name, agrees with PROSPECT.DBF fileè 2 CATEGORY <== Category # assigned, agrees with PROSPECT.DBF file
* 3 PERCENT_PD <== Percent Paid= ((Gross Paid/Gross Owed) x 100)
* 4 GROSS_OWED <== Gross Owed= summary of all positive activity entries
* 5 GROSS_PAID <== Gross Paid= summary of all negative activity entries
* 6 NET_OWED <== Net Owed= Gross owed - Gross Paid
# 7 STREAM <== 'Stream' selected for this debtor
# 8 ESCALATE_1 <== Escalate value #1: used with Escalate value # 2. If
both values are realized, then this debtor is
identified on Escalation Report. Escalate value #1
shows the number of days that must pass before this
debtor is so remiss as to warrant escalation, such as
direct phone calls.
# 9 ESCALATE_2 <== Escalate value #2: used with Escalate value # 1. If
both values are realized, then this debtor is
identified on Escalation Report. Escalate value #2
shows the minimum Percent Paid that this debtor
must attain during the days allowed in Escalate
value #1.
# 10 DE_ESCALAT <== De-escalation value. Once this optional Percentage
Paid is reached, all letters stop.
# 11 DE_ESCAL <== Logical field for de-escalation value.
* 12 LTRS_SENT <== numbers of letters that have been sent.
13 ACTIVATED <== is this feature activated or not?
* 14 STREAM_BGN <== Date letters began from this 'stream'
* 15 SEQUENCE <== Sequence of letter in current 'stream'
* 16 NEXT_LETTR <== number of next letter in this 'stream'
* 17 NEXT_LTR <== date of next letter due in this 'stream'
* 18 NXLTR_DTNL <== Days to Next Letter [DTNL] in this 'stream.'
Iµ zero¼átheε 'streamº i≤ finisheΣ anΣ STREAM_FI╬áse⌠át∩ True.
* 19 STREAM_FIN <== if 'stream' is finished, set to True; else False.
* 20 DATE_LASTL <== Date when last letter was sent
# 21 CROSSOVER <== Crossover value, if any, as a percentage. When this
value for Percent Paid is reached, crossover to second 'stream,'
then start over with the letters in that 'stream.'
# 22 CROSS_STRM <== Crossover 'stream.' When the crossover percentage
value is reached, crossover to this second 'stream' and
start over.
23 FIRST_ACT <== First Activity record entered with a non-zero value
in the revenue/expense field
[if '01/01/1901', then none entered yet]
24 MISC1 ---------
25 MISC2 |
26 MISC3 |
27 MISC4 |
28 MISC5 | ----> MISC1 through MISC10 used internally.
29 MISC6 |
30 MISC7 |
31 MISC8 |
32 MISC9 |
33 MISC10 ---------è 34 PROSPMEMO <== Memo for Payment Detail File. This program will
automatically create an on-going trail of documentation for audit purposes
of all relevant transactions.